Streamsets not loading JDBC driver

4,646 views
Skip to first unread message

Gow Tham

unread,
Dec 4, 2015, 1:56:15 AM12/4/15
to sdc-user
Hi, followed the guide(http://streamsets.com/documentation/datacollector/1.1.2/help/#Install_Config/AdditionalDrivers.html#concept_pdv_qlw_ft) and created a folder as specified and put in the mysql jdbc driver. Added it to the libs folder

xx@yyy:~/tmp/streamsets-datacollector-1.1.3/libs/streamsets-datacollector-mysql-lib/lib$ ls

mysql
-connector-java-5.1.29-bin.jar


The policy file, 

grant codebase "file://${sdc.dist.dir}/libs-" {
  permission java
.security.AllPermission;
};



Connection string 
jdbc:mysql://localhost/dbname

From the logs it looks like no driver is getting loaded 

...............................................................................................................................................
015-12-04 00:45:12,899 [user:] [pipeline:] [thread:main] INFO  Main - -----------------------------------------------------------------
2015-12-04 00:45:12,899 [user:] [pipeline:] [thread:main] INFO  Main - Starting ...
2015-12-04 00:45:17,424 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.jython.JythonDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jython_2_7-lib private=false]'
2015-12-04 00:45:17,425 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.scripting.ProcessingMode-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jython_2_7-lib private=false]'
2015-12-04 00:45:17,427 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.datacollector.creation.StageConfigBean-bundle' not found via ClassLoader 'SDCClassLoader[type=container-lib name=Container private=false]'
2015-12-04 00:45:17,428 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.api.OnRecordError-bundle' not found via ClassLoader 'SDCClassLoader[type=container-lib name=Container private=false]'
2015-12-04 00:45:17,429 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.jython.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jython_2_7-lib private=false]'
2015-12-04 00:45:17,429 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.api.StageDef$DefaultOutputStreams-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jython_2_7-lib private=false]'
2015-12-04 00:45:17,430 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.jdbc.JdbcDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jdbc-lib private=false]'
2015-12-04 00:45:17,432 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.jdbc.JdbcRecordType-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jdbc-lib private=false]'
2015-12-04 00:45:17,433 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.jdbc.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jdbc-lib private=false]'
2015-12-04 00:45:17,434 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.jdbc.JdbcDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jdbc-lib private=false]'
2015-12-04 00:45:17,436 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.lib.jdbc.ChangeLogFormat-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jdbc-lib private=false]'
2015-12-04 00:45:17,437 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.jdbc.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jdbc-lib private=false]'
2015-12-04 00:45:17,438 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.kafka.ToErrorKafkaDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,439 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.kafka.PartitionStrategy-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,440 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.config.CsvMode-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,441 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.config.CsvHeader-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,442 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.config.JsonMode-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,443 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.kafka.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,444 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.kafka.KafkaDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,446 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.config.DataFormat-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,448 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.kafka.KafkaDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,450 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.config.CsvRecordType-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,451 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.config.LogMode-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,452 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.config.OnParseError-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,454 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.kafka.KafkaRawSourcePreviewer-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,455 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.kafka.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_kafka_1_2_0-lib private=false]'
2015-12-04 00:45:17,456 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.mongodb.MongoDBDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-mongodb_3-lib private=false]'
2015-12-04 00:45:17,457 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.mongodb.AuthenticationType-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-mongodb_3-lib private=false]'
2015-12-04 00:45:17,458 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.mongodb.ReadPreferenceLabel-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-mongodb_3-lib private=false]'
2015-12-04 00:45:17,459 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.mongodb.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-mongodb_3-lib private=false]'
2015-12-04 00:45:17,461 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.hdfs.HdfsDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,463 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.hdfs.CompressionMode-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,464 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.hdfs.HdfsFileType-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,465 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.hdfs.HdfsSequenceFileCompressionType-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,466 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.hdfs.LateRecordsAction-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,471 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.hdfs.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,472 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.hdfs.cluster.ClusterHdfsDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,476 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.hdfs.cluster.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,477 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.hbase.HBaseDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,479 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.hbase.StorageType-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,480 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.hbase.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,481 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.flume.FlumeDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,482 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.flume.ClientType-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,483 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.flume.HostSelectionStrategy-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,486 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.flume.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,487 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.solr.SolrDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,488 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.solr.InstanceTypeOptions-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,490 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.solr.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_3-lib private=false]'
2015-12-04 00:45:17,491 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.elasticsearch.ElasticSearchDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-elasticsearch_1_4-lib private=false]'
2015-12-04 00:45:17,493 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.elasticsearch.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-elasticsearch_1_4-lib private=false]'
2015-12-04 00:45:17,496 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.logtail.FileTailDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,500 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.config.FileRollMode-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,502 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.config.PostProcessingOptions-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,504 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.api.base.FileRawSourcePreviewer-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,505 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.logtail.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,506 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.logtail.FileTailOutputStreams-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,506 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.devnull.NullDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,507 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.splitter.SplitterDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,508 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.config.OnStagePreConditionFailure-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,509 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.splitter.OriginalFieldAction-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,510 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.splitter.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,512 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.devnull.ToErrorNullDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,513 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.udp.UDPDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,513 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.udp.UDPDataFormat-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,515 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.udp.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,516 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.recordstolocalfilesystem.ToErrorLocalFSDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,517 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.recordstolocalfilesystem.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,518 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.logparser.LogParserDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,520 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.logparser.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,521 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.sdcipc.SdcIpcDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,522 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.sdcipc.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,523 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldrenamer.FieldRenamerDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,524 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldrenamer.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,525 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldtypeconverter.FieldTypeConverterDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,526 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.api.Field$Type-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,527 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.config.DateFormat-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,529 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldtypeconverter.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,530 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.http.HttpClientDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,531 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.http.HttpMethod-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,532 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.http.HttpClientMode-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,534 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.http.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,535 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldmask.FieldMaskDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,536 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldmask.MaskType-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,537 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldmask.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,538 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldmerger.FieldMergerDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,540 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldmerger.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,540 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.jsonparser.JsonParserDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,542 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.jsonparser.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,543 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.toerror.ToErrorDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,543 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.dedup.DeDupDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,544 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.dedup.SelectFields-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,545 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.dedup.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,546 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.dedup.OutputStreams-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,547 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.javascript.JavaScriptDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,549 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.javascript.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,550 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.expression.ExpressionDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,551 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.expression.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,552 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldfilter.FieldFilterDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,553 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldfilter.FilterOperation-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,554 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldfilter.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,555 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.sdcipc.SdcIpcDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,556 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.sdcipc.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,557 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldhasher.FieldHasherDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,558 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldhasher.HashType-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,559 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldhasher.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,560 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.geolocation.GeolocationDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,561 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.geolocation.GeolocationField-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,562 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.geolocation.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,563 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.spooldir.SpoolDirDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,565 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.config.FileCompression-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,571 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.spooldir.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,572 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.sdcipc.ToErrorSdcIpcDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,573 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.selector.SelectorDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,574 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.selector.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,575 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldvaluereplacer.FieldValueReplacerDProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,576 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.fieldvaluereplacer.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,577 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.omniture.OmnitureDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,578 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.omniture.HttpClientMode-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,579 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.omniture.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-basic-lib private=false]'
2015-12-04 00:45:17,619 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.hive.HiveDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_4-lib private=false]'
2015-12-04 00:45:17,621 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.hive.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cdh_5_4-lib private=false]'
2015-12-04 00:45:17,731 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.jms.JmsDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jms-lib private=false]'
2015-12-04 00:45:17,738 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.jms.JmsGroups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jms-lib private=false]'
2015-12-04 00:45:17,739 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.cassandra.CassandraDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cassandra_2-lib private=false]'
2015-12-04 00:45:17,740 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.cassandra.CassandraCompressionCodec-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cassandra_2-lib private=false]'
2015-12-04 00:45:17,741 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.cassandra.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-cassandra_2-lib private=false]'
2015-12-04 00:45:17,790 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.kinesis.KinesisDTarget-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-aws-lib private=false]'
2015-12-04 00:45:17,791 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.amazonaws.regions.Regions-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-aws-lib private=false]'
2015-12-04 00:45:17,793 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.kinesis.PartitionStrategy-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-aws-lib private=false]'
2015-12-04 00:45:17,794 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.destination.kinesis.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-aws-lib private=false]'
2015-12-04 00:45:17,795 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.kinesis.KinesisDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-aws-lib private=false]'
2015-12-04 00:45:17,797 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.kinesis.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-aws-lib private=false]'
2015-12-04 00:45:17,798 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.s3.AmazonS3DSource-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-aws-lib private=false]'
2015-12-04 00:45:17,805 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.s3.S3ArchivingOption-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-aws-lib private=false]'
2015-12-04 00:45:17,806 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.s3.Groups-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-aws-lib private=false]'
2015-12-04 00:45:17,807 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.devtest.RandomSource-bundle' not found via ClassLoader 'SDCClassLoader[type=user-libs name=streamsets-datacollector-dev-lib private=false]'
2015-12-04 00:45:17,809 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.processor.identity.IdentityProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=user-libs name=streamsets-datacollector-dev-lib private=false]'
2015-12-04 00:45:17,810 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.devtest.RandomErrorProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=user-libs name=streamsets-datacollector-dev-lib private=false]'
2015-12-04 00:45:17,810 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.devtest.RandomDataGeneratorSource-bundle' not found via ClassLoader 'SDCClassLoader[type=user-libs name=streamsets-datacollector-dev-lib private=false]'
2015-12-04 00:45:17,811 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.devtest.rawdata.RawDataDSource-bundle' not found via ClassLoader 'SDCClassLoader[type=user-libs name=streamsets-datacollector-dev-lib private=false]'
2015-12-04 00:45:17,817 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.devtest.rawdata.RawDataSourceGroups-bundle' not found via ClassLoader 'SDCClassLoader[type=user-libs name=streamsets-datacollector-dev-lib private=false]'
2015-12-04 00:45:17,818 [user:] [pipeline:] [thread:main] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.devtest.RecordCreatorProcessor-bundle' not found via ClassLoader 'SDCClassLoader[type=user-libs name=streamsets-datacollector-dev-lib private=false]'
2015-12-04 00:45:18,439 [user:] [pipeline:] [thread:main] INFO  Reflections - Reflections took 164 ms to scan 1 urls, producing 156 keys and 661 values 
2015-12-04 00:45:19,377 [user:] [pipeline:] [thread:main] INFO  WebServerTask - Running on URI 'http://xxxxxxx:18630/', HTTPS 'false' 
2015-12-04 00:45:29,128 [user:admin] [pipeline:*] [thread:qtp1086128725-24] INFO  StandaloneAndClusterRunnerProviderImpl - Pipeline execution mode is: STANDALONE 
2015-12-04 00:45:29,137 [user:admin] [pipeline:*] [thread:qtp1086128725-24] INFO  StandaloneAndClusterRunnerProviderImpl - Pipeline execution mode is: STANDALONE 
2015-12-04 00:45:29,698 [user:admin] [pipeline:] [thread:qtp1086128725-28] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.datacollector.creation.PipelineConfigBean-bundle' not found via ClassLoader 'SDCClassLoader[type=container-lib name=Container private=false]'
2015-12-04 00:45:29,698 [user:admin] [pipeline:] [thread:qtp1086128725-28] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.api.ExecutionMode-bundle' not found via ClassLoader 'SDCClassLoader[type=container-lib name=Container private=false]'
2015-12-04 00:45:29,700 [user:admin] [pipeline:] [thread:qtp1086128725-28] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.datacollector.config.DeliveryGuarantee-bundle' not found via ClassLoader 'SDCClassLoader[type=container-lib name=Container private=false]'
2015-12-04 00:45:29,701 [user:admin] [pipeline:] [thread:qtp1086128725-28] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.datacollector.config.MemoryLimitExceeded-bundle' not found via ClassLoader 'SDCClassLoader[type=container-lib name=Container private=false]'
2015-12-04 00:45:29,702 [user:admin] [pipeline:] [thread:qtp1086128725-28] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.datacollector.config.PipelineGroups-bundle' not found via ClassLoader 'SDCClassLoader[type=container-lib name=Container private=false]'
2015-12-04 00:45:33,004 [user:admin] [pipeline:Test] [thread:qtp1086128725-28] INFO  ManagerResource - Status is START_ERROR
2015-12-04 00:46:24,523 [user:admin] [pipeline:Test] [thread:qtp1086128725-24] INFO  StandaloneRunner - Preparing to start pipeline 'Test::0'
2015-12-04 00:46:24,537 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1] INFO  StandaloneRunner - Starting pipeline Test 0
2015-12-04 00:46:25,164 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] INFO  HikariDataSource - HikariCP pool HikariPool-0 is starting.
2015-12-04 00:46:25,174 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] ERROR JdbcSource - Failed to initialize connection pool: {}
java.lang.RuntimeException: Unable to get driver for JDBC URL jdbc:mysql://localhost/db
at com.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:55)
at com.zaxxer.hikari.pool.PoolUtilities.initializeDataSource(PoolUtilities.java:107)
at com.zaxxer.hikari.pool.BaseHikariPool.<init>(BaseHikariPool.java:153)
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:61)
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:49)
at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:80)
at com.streamsets.pipeline.stage.origin.jdbc.JdbcSource.createDataSource(JdbcSource.java:347)
at com.streamsets.pipeline.stage.origin.jdbc.JdbcSource.init(JdbcSource.java:155)
at com.streamsets.pipeline.api.base.BaseStage.init(BaseStage.java:37)
at com.streamsets.pipeline.configurablestage.DStage.init(DStage.java:38)
at com.streamsets.datacollector.runner.StageRuntime.init(StageRuntime.java:126)
at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:89)
at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:46)
at com.streamsets.datacollector.runner.Pipeline.init(Pipeline.java:138)
at com.streamsets.datacollector.execution.runner.common.ProductionPipeline.run(ProductionPipeline.java:94)
at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunnable.run(ProductionPipelineRunnable.java:70)
at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.start(StandaloneRunner.java:673)
at com.streamsets.datacollector.execution.runner.common.AsyncRunner$3.call(AsyncRunner.java:131)
at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:231)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:278)
at com.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:52)
... 24 more
2015-12-04 00:46:25,176 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.pipeline.stage.origin.jdbc.Errors-bundle' not found via ClassLoader 'SDCClassLoader[type=streamsets-libs name=streamsets-datacollector-jdbc-lib private=false]'
2015-12-04 00:46:25,400 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] INFO  HdfsTarget - Subject = Subject:
Principal: UnixPrincipal: gowtham
Principal: UnixNumericUserPrincipal: 1000
Principal: UnixNumericGroupPrincipal [Primary Group]: 1000
Principal: UnixNumericGroupPrincipal [Supplementary Group]: 27
Principal: UnixNumericGroupPrincipal [Supplementary Group]: 100
Principal: UnixNumericGroupPrincipal [Supplementary Group]: 1006
Principal: gowtham
, Principals = [UnixPrincipal: gowtham, UnixNumericUserPrincipal: 1000, UnixNumericGroupPrincipal [Primary Group]: 1000, UnixNumericGroupPrincipal [Supplementary Group]: 27, UnixNumericGroupPrincipal [Supplementary Group]: 100, UnixNumericGroupPrincipal [Supplementary Group]: 1006, gowtham], Login UGI = gowtham (auth:SIMPLE)
2015-12-04 00:46:25,759 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] INFO  HdfsTarget - Authentication Config: Using Simple
2015-12-04 00:46:25,938 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] INFO  HdfsTarget - Destroy
2015-12-04 00:46:25,946 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] WARN  LocalizableMessage - ResourceBundle 'com.streamsets.datacollector.util.ContainerError-bundle' not found via ClassLoader 'SDCClassLoader[type=container-lib name=Container private=false]'
2015-12-04 00:46:25,947 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] ERROR ProductionPipelineRunnable - An exception occurred while running the pipeline, com.streamsets.datacollector.runner.PipelineRuntimeException: CONTAINER_0800 - Pipeline 'Test' validation error : JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: java.sql.SQLException: No suitable driver
com.streamsets.datacollector.runner.PipelineRuntimeException: CONTAINER_0800 - Pipeline 'Test' validation error : JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: java.sql.SQLException: No suitable driver
at com.streamsets.datacollector.execution.runner.common.ProductionPipeline.run(ProductionPipeline.java:124)
at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunnable.run(ProductionPipelineRunnable.java:70)
at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.start(StandaloneRunner.java:673)
at com.streamsets.datacollector.execution.runner.common.AsyncRunner$3.call(AsyncRunner.java:131)
at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:231)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
2015-12-04 00:46:25,947 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] INFO  ProductionPipelineRunnable - Cancelling task java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask@5446dee6
2015-12-04 00:46:25,947 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] INFO  ProductionPipelineRunnable - Cancelling task java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask@78d3f943
2015-12-04 00:46:25,947 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] INFO  ProductionPipelineRunnable - Cancelling task java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask@2491dbae
2015-12-04 00:46:25,947 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] INFO  ProductionPipelineRunnable - Cancelling task java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask@63ed8f43
2015-12-04 00:46:25,947 [user:*admin] [pipeline:Test] [thread:runner-pool-2-thread-1-ProductionPipelineRunnable] INFO  ProductionPipelineRunnable - Cancelling task java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask@158aaf6

java version running, 
java version "1.8.0_66"
Java(TM) SE Runtime Environment (build 1.8.0_66-b17)
 
Why does this happen, downloaded a new version to stream sets just to check it, still happens.

Brock Noland

unread,
Dec 4, 2015, 8:08:20 AM12/4/15
to Gow Tham, sdc-user
Hi,

I believe "streamsets-datacollector-mysql-lib" should be "streamsets-datacollector-jdbc-lib."

Cheers,
Brock
--
You received this message because you are subscribed to the Google Groups "sdc-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+u...@streamsets.com.
Visit this group at http://groups.google.com/a/streamsets.com/group/sdc-user/.

Lestan D'Souza

unread,
Jan 26, 2016, 4:34:27 PM1/26/16
to sdc-user
I have the same exact issue.  Were you able to get this resolved?
...

Jonathan Natkins

unread,
Jan 26, 2016, 4:50:55 PM1/26/16
to Lestan D'Souza, sdc-user
Hi Lestan,

If you want to avoid mucking with the sdc-security.policy, the libs-common-lib directory exists for this purpose, and is already set up appropriately. The following steps should get you going:
  1. In the SDC directory, run `mkdir -p libs-common-lib/streamsets-datacollector-jdbc-lib/lib`
  2. Copy the JDBC driver to libs-common-lib/streamsets-datacollector-jdbc-lib/lib. If the directory does not match this exactly, the driver won't be picked up properly.
  3. Open up file libexec/sdc-env.sh (note if you've installed via RPM, you'll actually want to modify sdcd-env.sh), and add the line: export STREAMSETS_LIBRARIES_EXTRA_DIR=libs-common-lib
  4. Restart the Data Collector
If you run `ps aux | grep sdc`, you should see "-streamsetsLibrariesExtraDir libs-common-lib" at the end of the process command, which will indicate that the directory has been picked up properly.

If you still can't get this working, let me know what issues you're seeing in StreamSets when you try to run the pipeline, and I can help further.

Thanks!
Natty


Jonathan "Natty" Natkins
StreamSets | Field Engineer


--
You received this message because you are subscribed to the Google Groups "sdc-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+u...@streamsets.com.

Les D'Souza

unread,
Jan 27, 2016, 10:36:36 AM1/27/16
to Jonathan Natkins, sdc-user
Hi Natty,

Thanks for the tip.  I tried to install via the RPM this time and it worked fine.  I busted your suggestion and just included the driver in the libs-common-lib directory.

Appreciate your help.

Les

Jonathan Natkins

unread,
Jan 27, 2016, 10:49:27 AM1/27/16
to Les D'Souza, sdc-user
Glad to hear it worked for you!
--
Message has been deleted

Jonathan Natkins

unread,
Jun 8, 2016, 11:01:50 AM6/8/16
to raphaël velfre, sdc-user
Hey Raphael,

I would double check that you correctly added the STREAMSETS_LIBRARIES_EXTRA_DIR environment variable to your sdc-env.sh (sdcd-env.sh if you installed via RPM). You'll want to set it to libs-common-lib. Just add the following line to that file:

export STREAMSETS_LIBRARIES_EXTRA_DIR=libs-common-lib

If you run a ps aux on the process, you should see at the end of it something like -streamsetsLibrariesExtraDir libs-common-lib

The other thing I would check on is if that driver contains the appropriately-named driver. You can use jar -tf /opt/streamsets-datacollector-1.4.0.0/libs-common-lib/streamsets-datacollector-jdbc-lib/lib to do that. I believe the actual package that the Hive driver is in has changed a bit over time, so just want to make sure you have the correct Driver name. Also, I believe there are multiple JARs that have to be included for Hive, such as the metastore.jar. Make sure you have every required JAR in that directory.

Thanks!
Natty

Jonathan "Natty" Natkins
StreamSets | Field Engineer


On Wed, Jun 8, 2016 at 5:43 AM, raphaël velfre <raphael...@gmail.com> wrote:
Hi Jonathan,

I'm running a MapR cluster and I would like to query Hive using the JDBC sdc component.

I configured it properly I think but I've got the following error :

JDBC_01 - Failed to create JDBC driver, JDBC driver JAR may be missing: java.lang.ClassNotFoundException: org.apache.hadoop.hive.jdbc.HiveDriver

My JDBC connexion string : jdbc:hive2://192.168.216.128:10000/default
Class used = org.apache.hadoop.hive.jdbc.HiveDriver

I also imported my .jar into /opt/streamsets-datacollector-1.4.0.0/libs-common-lib/streamsets-datacollector-jdbc-lib/lib
Finally, I checked that the class I'm using is included in that driver (using jar tf command).

Could you help me ?

Thanks.

raphaël velfre

unread,
Jun 8, 2016, 11:12:16 AM6/8/16
to sdc-user, raphael...@gmail.com
Hey Jonathan,

My fault the driver was org.apache.hive.jdbc.HiveDriver instead of org.apache.hadoop.hive.jdbc.HiveDriver :)

However I've got an other issue : JDBC_06 - Failed to initialize connection pool: java.sql.SQLException: enabling autocommit is not supported
But this one is due to Hive autocommit not supported.

This has been reported in JIRA and has been implemented in Hive 2.0 : https://issues.apache.org/jira/browse/HIVE-6712

Thanks for you help :)

Raphaël



...

Jonathan Natkins

unread,
Jun 8, 2016, 11:19:39 AM6/8/16
to raphaël velfre, sdc-user
No problem! Happy to help!

Jonathan "Natty" Natkins
StreamSets | Field Engineer


--
You received this message because you are subscribed to the Google Groups "sdc-user" group.

Adam Kunicki

unread,
Jun 8, 2016, 11:40:15 AM6/8/16
to raphaël velfre, sdc-user
Yep, we're aware of that Hive driver issue. If possible you can try the Cloudera Hive JDBC driver as it does not have this bug. http://www.cloudera.com/downloads/connectors/hive/jdbc/2-5-16.html

Also, keep in mind that it may take a LONG time currently to start the pipeline as a validation query is run prior to starting the pipeline. This can take a long time to complete (you can monitor progress via the YARN resource manager).

This is already being tracked via this ticket: https://issues.streamsets.com/browse/SDC-2778

-Adam

Adam Kunicki
StreamSets | Field Engineer
mobile: 415.890.DATA (3282) | linkedin

--
You received this message because you are subscribed to the Google Groups "sdc-user" group.

Jonas

unread,
Aug 21, 2016, 11:09:21 AM8/21/16
to sdc-user
Hi 

Im running the docker container Streamsets Datacollector on CoreOS. I succeed in getting the datacollector up&running and accessing the gui. But then I should install my jdbc driver and modifying the env variables as decribed below.
Im am user "sdc"in the container.

But the sdc-env.sh is readonly. 

How can I update this env file in the container ?

Regards

Jonas
...

Adam Kunicki

unread,
Aug 21, 2016, 12:28:11 PM8/21/16
to Jonas, sdc-user


Hi Jonas,
You should either create a volume with your customized configuration files or you can derive a new image with your customizations.

-Adam



--

Jonas

unread,
Aug 21, 2016, 4:43:06 PM8/21/16
to sdc-user, jona...@gmail.com
I created a data volume according to the docker user guide, 
looked up the source in CoreOS of the mounted data volume w command (docker inspect "containername")  
got sudo in CoreOS w "sudo su"
went to the source folder in CoreOS and edited the file.
logged into the container and the sdc-env.sh file was updated.

thank you Adam for your advice. Now next step for getting the jdbcdriver installed.

/Jonas
...

Ken Tore Tallakstad

unread,
Nov 22, 2016, 9:11:23 AM11/22/16
to sdc-user, raphael...@gmail.com
using the Cloudera Hive JDBC driver as suggested with "com.cloudera.hive.jdbc41.HS2Driver" as the Legacy Driver Class works perfectly for me. There is no longer a need for a custom Connection Health Test Query.   :) 

- Kent
...

Olivier

unread,
Dec 15, 2016, 5:45:48 AM12/15/16
to sdc-user, raphael...@gmail.com
This workaround  did not work for me :( I did try with com.cloudera.hive.jdbc41.HS2Driver but also com.cloudera.hive.jdbc4.HS2Driver or com.cloudera.hive.jdbc3.HS2Driver with no luck.

I do get the following error with Cloudera drivers "JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: java.sql.SQLException: [Cloudera][HiveJDBCDriver](500151) Error setting/closing session: Open Session Error."

What is strange is that the Hive Metastore destination is working fine with CDH 5.4 (Hive 0.11) so I did try to either link or copies jars from streamsets-libs/streamsets-datacollector-cdh_5_4-lib to libs-common-lib but in this case SDC won't start with NoClassDefFound exception (duplicate class definition)

Any idea on how to use the same drivers for JDBC origins as the ones used by SDC for Hive metadata destination?

Thanks in advance

Pat Patterson

unread,
Dec 15, 2016, 2:45:42 PM12/15/16
to Olivier, sdc-user, raphaël velfre
Hi Olivier,

I did a bit of searching - this StackOverflow answer suggests some possible solutions in crafting the JDBC Connection String. What are you using there?

Cheers,

Pat

--

Pat Patterson | Community Champion | http://about.me/patpatterson

--
You received this message because you are subscribed to the Google Groups "sdc-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+unsubscribe@streamsets.com.

Olivier

unread,
Dec 22, 2016, 5:51:42 AM12/22/16
to sdc-user, odesg...@gmail.com, raphael...@gmail.com
Thanks for the tip Pat,

I am not using SSL nor Kerberos authentication. From Cloudera documentation (https://www.cloudera.com/documentation/other/connectors/hive-jdbc/latest/Cloudera-JDBC-Driver-for-Apache-Hive-Install-Guide.pdf) I have tested with AuthMech=0;transportMode=binary and also AuthMech=3;UID=xxx;PWD=yyy but each time I end up with the same error

"JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.
StageException: JDBC_06 - Failed to initialize connection pool: java.sql.SQLException: [Cloudera][HiveJDBCDriver](500151) Error setting/closing session: Open Session Error."




...

Pat Patterson

unread,
Dec 22, 2016, 10:59:42 AM12/22/16
to Olivier, sdc-user, raphaël velfre
Hi Olivier,

Can you share the whole stack trace from the log?

Cheers,

Pat

--

Pat Patterson | Community Champion | http://about.me/patpatterson

--
Message has been deleted

Jonas

unread,
Jan 29, 2017, 11:37:41 AM1/29/17
to sdc-user, odesg...@gmail.com, raphael...@gmail.com
I faced problems connecting from Sdc to database Crate with their jdbc-driver. My solution was to uncheck the option "Enforce Read-only Connection" under Advanced tab in the jdbc-origin stage. Dont know if that your solution but thats an idea.
/J

Pavithra

unread,
Mar 7, 2017, 4:08:46 PM3/7/17
to sdc-user, jona...@gmail.com
Hello Jonas,

I have just started studying about docker, container, JDBC Driver.

I am also facing the issue with the file permissions.

You have mentioned here to create volume or derive new image for custom config.

But when I go through this link,


It was mentioned that deriving a new image is a good solution.

Could you please say me how to do it? 

Custom image of streamsets with these file permissions alone?
...

Anand Bitra

unread,
Jun 2, 2017, 5:29:52 PM6/2/17
to sdc-user, les...@gmail.com
I followed these instructions, but I am getting below error. Do I need to fill up Leagacy Drivers tab? 

JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: java.lang.RuntimeException: Unable to get driver instance for jdbcUrl

# ps aux | grep sdc
sdc      20454 10.0  1.0 8602544 672084 ?      Sl   17:17   1:13 /usr/java/jdk1.8.0_131/bin/java -classpath /opt/streamsets-datacollector/libexec/bootstrap-libs/main/streamsets-datacollector-bootstrap-2.5.0.0.jar:/opt/streamsets-datacollector/root-lib/* -Djava.security.manager -Djava.security.policy=file:///etc/sdc/sdc-security.policy -Xmx1024m -Xms1024m -server -XX:-OmitStackTraceInFastThrow -Dsdc.dist.dir=/opt/streamsets-datacollector -Dsdc.resources.dir=/var/lib/sdc/resources -Dsdc.hostname=ustsmascmsp695.prod -Dsdc.conf.dir=/etc/sdc -Dsdc.data.dir=/var/lib/sdc -Dsdc.log.dir=/var/log/sdc -javaagent:/opt/streamsets-datacollector/libexec/bootstrap-libs/main/streamsets-datacollector-bootstrap-2.5.0.0.jar -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/var/log/sdc/heapdump -XX:+PrintGCDetails -XX:+PrintGCDateStamps -Xloggc:/var/log/sdc/gc.log com.streamsets.pipeline.BootstrapMain -mainClass com.streamsets.datacollector.main.DataCollectorMain -apiClasspath /opt/streamsets-datacollector/api-lib/*.jar -containerClasspath /etc/sdc:/opt/streamsets-datacollector/container-lib/*.jar -streamsetsLibrariesDir /opt/streamsets-datacollector/streamsets-libs -userLibrariesDir /opt/streamsets-datacollector/user-libs/ -configDir /etc/sdc -libsCommonLibDir /opt/streamsets-datacollector/libs-common-lib/ -streamsetsLibrariesExtraDir /opt/streamsets-datacollector/libs-common-lib

Appreciate your help in this regard.

Anand

Pat Patterson

unread,
Jun 2, 2017, 6:53:11 PM6/2/17
to Anand Bitra, sdc-user, les...@gmail.com
What is your JDBC URL?

Cheers,

Pat

--

Pat Patterson | Community Champion | http://about.me/patpatterson

To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+unsubscribe@streamsets.com.

Anand Bitra

unread,
Jun 2, 2017, 6:55:26 PM6/2/17
to sdc-user, les...@gmail.com
I was trying to connect hive in cloudera. Do I need to copy any hive-jdbc.jar file in this folder?

/opt/streamsets-datacollector/libs-common-lib/streamsets-datacollector-jdbc-lib/lib/streamsets-datacollector-jdbc-lib-2.5.0.0.jar

Pat Patterson

unread,
Jun 2, 2017, 7:58:05 PM6/2/17
to Anand Bitra, sdc-user, les...@gmail.com

Cheers,

Pat

--

Pat Patterson | Community Champion | http://about.me/patpatterson

To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+unsubscribe@streamsets.com.

Arjit Yadav

unread,
Nov 7, 2017, 9:23:49 AM11/7/17
to sdc-user, les...@gmail.com
Hi,

I followed the exact same process but I am getting following error :-

JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: java.lang.RuntimeException: Driver oracle.jdbc.OracleDriver claims to not accept JDBC URL jdbc:oracle://192.168.56.102:22/ORCL

I have ojdbc6-11.2.0.2.0.jar inside /opt/streamsets-datacollector/libs-common-lib/streamsets-datacollector-jdbc-lib/lib

and

I have export STREAMSETS_LIBRARIES_EXTRA_DIR=libs-common-lib in the /opt/streamsets-datacollector/libexec

Where am I going wrong ?

Regards,

Pat Patterson

unread,
Nov 7, 2017, 1:04:54 PM11/7/17
to Arjit Yadav, sdc-user, Lestan D'Souza
Hi Arjit,

I think you have the JDBC connection string wrong. It should be more like:


Cheers,

Pat

--

Pat Patterson | Community Champion | http://about.me/patpatterson

To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+unsubscribe@streamsets.com.

r.m...@plenium.com

unread,
Apr 10, 2018, 6:35:20 PM4/10/18
to sdc-user, arjit...@gmail.com, les...@gmail.com
Hello,

I installed Streamsets using Cloudera Manager. Trying to use a simple JDBC Query Consumer and get a validation error:

JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: java.lang.RuntimeException: Unable to get driver instance for jdbcUrl=jdbc:oracle:thin:@//xxxx.com:1521/xxxx.com

The following directory is empty:  /opt/cloudera/parcels/STREAMSETS_DATACOLLECTOR-3.1.2.0/libs-common-lib

What to do to connect to Oracle using JDBC?

-RM


On Tuesday, November 7, 2017 at 1:04:54 PM UTC-5, Pat Patterson wrote:
Hi Arjit,

I think you have the JDBC connection string wrong. It should be more like:

ankam...@gmail.com

unread,
Aug 22, 2018, 1:28:29 AM8/22/18
to sdc-user, gowkan...@gmail.com
Creating New Pipeline in Streamsets add jdbc driver and restart sdc service will help to run/connect data queries against any data collection.


Above is the URL i found very useful and step by step guide to deploy JDBC driver.
Reply all
Reply to author
Forward
0 new messages